Quản lý website giới thiệu và bán điện thoại di động ASP.net
19.291 lượt xem;
- Default.aspx.cs
- project /
1 using System;
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using SiteUtils;
12 using System.Data.OleDb;
13
14 public partial class Default : System.Web.UI.Page
15 {
16 protected void Page_Load(object sender, EventArgs e)
17 {
18 ado.ketNoi();
19 string query = "SELECT tblsanpham.masp,'chitiet.aspx?tensp='+tensp as chitiet, tblsanpham.mahang, tblsanpham.tensp, tblsanpham.gia, tblsanpham.soluong, tblsanpham.dacdiem, tblsanpham.baohanh, tblsanpham.khuyenmai, tblsanpham.kieudang, tblsanpham.phongcach, tblsanpham.anh, tblsanpham.ghichu, tblhang.tenhang FROM (tblsanpham INNER JOIN tblhang ON tblsanpham.mahang = tblhang.mahang) WHERE (tblsanpham.phongcach='độc đáo')";
20 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
21 DataSet dataset = new DataSet();
22 adapter.Fill(dataset);
23 clp1.PageSize = 12;
24 clp1.DataSource = dataset.Tables[0].DefaultView;
25 clp1.BindToControl = DataList1;
26 DataList1.DataSource = clp1.DataSourcePaged;
27 //Download source code tại Sharecode.vn
28 }
29 protected void DataList2_SelectedIndexChanged(object sender, EventArgs e)
30 {
31
32 }
33 }
2 using System.Data;
3 using System.Configuration;
4 using System.Collections;
5 using System.Web;
6 using System.Web.Security;
7 using System.Web.UI;
8 using System.Web.UI.WebControls;
9 using System.Web.UI.WebControls.WebParts;
10 using System.Web.UI.HtmlControls;
11 using SiteUtils;
12 using System.Data.OleDb;
13
14 public partial class Default : System.Web.UI.Page
15 {
16 protected void Page_Load(object sender, EventArgs e)
17 {
18 ado.ketNoi();
19 string query = "SELECT tblsanpham.masp,'chitiet.aspx?tensp='+tensp as chitiet, tblsanpham.mahang, tblsanpham.tensp, tblsanpham.gia, tblsanpham.soluong, tblsanpham.dacdiem, tblsanpham.baohanh, tblsanpham.khuyenmai, tblsanpham.kieudang, tblsanpham.phongcach, tblsanpham.anh, tblsanpham.ghichu, tblhang.tenhang FROM (tblsanpham INNER JOIN tblhang ON tblsanpham.mahang = tblhang.mahang) WHERE (tblsanpham.phongcach='độc đáo')";
20 OleDbDataAdapter adapter = new OleDbDataAdapter(query, ado.con);
21 DataSet dataset = new DataSet();
22 adapter.Fill(dataset);
23 clp1.PageSize = 12;
24 clp1.DataSource = dataset.Tables[0].DefaultView;
25 clp1.BindToControl = DataList1;
26 DataList1.DataSource = clp1.DataSourcePaged;
27 //Download source code tại Sharecode.vn
28 }
29 protected void DataList2_SelectedIndexChanged(object sender, EventArgs e)
30 {
31
32 }
33 }